Search results for "Database design"
showing 9 items of 9 documents
Database Versioning 2.0, a Transparent SQL Approach Used in Quantitative Management and Decision Making
2015
Abstract Managerial decisions are based on accurate information and in today's time raw data is produced even with a stroke of a key. Regardless of the data creating process one needs to know how the information was extracted and which pool of data was used. One important factor is time therefore we need to structure it in layers of data history in such a way that it can be analyzed, (post)process, in order to be able to retrieve valuable information. The simplest way is to use a Database Management System (DBMS), but even with such a management system we face the issue of making it a self-contained database on each version of data added. Our proposed system, a continuation of previous work…
Grammars++ for modelling information in text
1999
Abstract Grammars provide a convenient means to describe the set of valid instances in a text database. Flexibility in choosing a grammar can be exploited to provide information modelling capability by designing productions in the grammar to represent entities and relationships of interest to database applications. Additional constraints can be specified by attaching predicates to selected nonterminals in the grammar. When used for database definition, grammars can provide the functionality that users have come to expect of database schemas. Extended grammars can also be used to specify database manipulation, including query, update, view definition, and index specification.
Migration of Relational Database to Document-Oriented Database: Structure Denormalization and Data Transformation
2015
Relational databases remain the leading data storage technology. Nevertheless, many companies want to reduce operating expenses, to make scalable applications that use cloud computing technologies. Use of NoSQL database is one of the possible solutions, and it is forecasted that the NoSQL market will be growing at a CAGR of approximately 50 percent over the next five years. The paper offers a solution for quick data migration from a relational database into a document-oriented database. We have created semi-automatically two logical levels over physical data. Users can refine generated logical data model and configure data migration template for each needed document. Data migration features…
PDB: A pictorial database oriented to data analysis
1993
The paper describes a new pictorial database oriented to image analysis, implemented inside the MIDAS data analysis system. Pictorial databases need expressive data structures in order to represent a wide class of information from the numerical to the visual. The model of the database is relational; however, a full normalization is not achievable, owing to the complexity of the visual information. The paper reports the general design and notes on the software implementation. Preliminary experiments show the performance of the pictorial database. Copyright © 1993 John Wiley & Sons, Ltd
Errors and Complications in SQL Query Formulation
2018
SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature, present a class of logical errors that has not been studied in detail, and review and complement these findings by analyzing over 33,000 SQL queries submitted by students. Our analysis verifies error findings presented in previous literature and reveals new types of errors, namely logical errors recurring in similar manners among different students. We…
From Databases to Ontologies
2009
This chapter introduces the UML profile for OWL as an essential instrument for bridging the gap between the legacy relational databases and OWL ontologies. We address one of the long-standing relational database design problems where initial conceptual model (a semantically clear domain conceptualization ontology) gets “lost” during conversion into the normalized database schema. The problem is that such “loss” makes database inaccessible for direct query by domain experts familiar with the conceptual model only. This problem can be avoided by exporting the database into RDF according to the original conceptual model (OWL ontology) and formulating semantically clear queries in SPARQL over t…
Proteomics of Galápagos Marine Iguanas Links Function of Femoral Gland Proteins to the Immune System
2020
Femoral glands secrete a wax-like substance on the inner side of lizard hind legs, which is thought to function as a mode of chemical communication. Though the minor volatile fraction is well studied, the major protein fraction remains enigmatic. Here, we use proteomics to analyze proteins in femoral gland secretions of the Galápagos marine iguana. Although we found no evidence for proteins and peptides involved in chemical communication, we found several immune-regulatory proteins which also demonstrate anti-microbial functions. Accordingly, we show that femoral gland proteins and peptides function as a barrier against microbial infection and may prevent the rapid degradation of volatile s…
Heterogeneous Database Browsing in WWW Based on Meta Model of Data Sources
2001
This paper describes a development principle and technique for a simple universal multiple database browser. The browser operates by getting information from metamodel of data sources and actual data from legacy data sources. Every element such as entity, field, and relation is mapped to some component of HTML page with appropriate structure and layout. Many templates of information layouts can be created allowing to dynamical changing of HTML page to acceptable user interface. The wrappers are used to provide browser with actual data and to act as mediators between data sources and browser. This approach allows to quickly describing new data sources, creating wrappers, making modifications…
Towards an Ontology for Information Systems Development—A Contextual Approach
2007
This chapter presents an ISD ontology, which aims to provide an integrated conceptualization of ISD through anchoring it upon a contextual approach. The ISD ontology is composed of concepts, relationships, and constraints referring to purposes, actors, actions, and objects of ISD. It is presented as a vocabulary with explicit definitions and in meta models in a UML-based ontology representation language. We believe that although not complete the ISD ontology can promote the achievement of a shared understanding of contextual aspects in ISD. It can be used to analyze and compare existing frameworks and meta models and as a groundwork for engineering new ISD methods, and parts thereof. IGI PU…